<?php 
require_once("../connect_db.php");
$sqlTeacher4="select * from student,course,orders,meeting
where student.std_id=orders.std_id and orders.order_id=meeting.order_id
and orders.course_id=course.course_id 
and meet_status='Y' and teach_id='".$_GET["temp"]."' and meet_datetime>='".$_GET["start"]."' and meet_datetime<='".$_GET["stop"]."' group by meeting.meet_id";
$queryTeacher4=mysql_query($sqlTeacher4);
?>
<button class="btn btn-success" onClick="Javascript:$('.split2').hide();$('.split1').show();">&#8592;ย้อนกลับ</button>
<div style="margin-top:20px;">
<h2>ผู้สอน : <?php echo $_GET["name"]?></h2>
</div>
<form method="post" enctype="multipart/form-data" name="frmreg" id="frmreg">

<div class="row">
	<div class="col-md-12">
		<div class="panel">
		 
		  <div class="panel-body">
		
		  
			<table cellpadding="0" cellspacing="0" border="0" class="display" id="Teacher2" width="100%" style="font-size:14px">
	<thead>
		<tr>
			<th style="width:17%;text-align: center !important;color:black; !important;font-size:1em">ผู้เรียน</th>
			<th style="width:15%;text-align: center !important;color:black; !important;font-size:1em">หลักสูตร</th>
			<th style="width:13%;text-align: center !important;color:black; !important;font-size:1em">วันที่ทำการสอน</th>
			<th style="width:20%;text-align: center !important;color:black; !important;font-size:1em">หมายเหตุ</th>
		</tr>
	</thead>
	<tbody style="color:black !important;">
	
		<?php while($resultTeacher4=mysql_fetch_array($queryTeacher4)){?>
		<tr>
			<td style="text-align: center !important;color:black; !important;font-size:1em"><?php echo $resultTeacher4["std_name"]." ".$resultTeacher4["std_lname"]?></td>
			<td style="text-align: center !important;color:black; !important;font-size:1em"><?php echo $resultTeacher4["course_name"]?></td>
			<td style="text-align: center !important;color:black; !important;font-size:1em"><?php echo $resultTeacher4["meet_datetime"]?></td>
			<td style="text-align: center !important;color:black; !important;font-size:1em"><?php echo $resultTeacher4["meet_remark"]?></td>
		</tr>
		<?php }?>
	</tbody>
	
</table>
		  </div>
		</div>
	</div>
</div>
</div>


</form>
<script>


$(document).ready(function(){
var oTable2;
  	oTable2 = $('#Teacher2').dataTable({
          "bJQueryUI": true,
          "sPaginationType": "full_numbers"
      });

 
});
	 
</script>
